2013-04-23-5914.600-Spec - Customer Segmentation Extract #RocApplication #ABAPEXTRACT

SPECIFICATIONS

5914.600-Spec - Customer Segmentation Extract

Purpose

Develop a program which generates an Extract file listing key combinations Customer / Collection and Sales Org / Collection / Customer Group 9 and can be sent from SAP to ROC

Admin Info

Purpose	Program to extract Customer Listing Data
Requested By	Daniel Brennan
Spec Created By	Venkat Kondapally
Spec Created Date	04/23/2013
Spec QA by	Venkat Kondapally
Objects	ZISD_CUSTOMER_LISTING_EXTRACT
Document Status	Complete

References

Prior Tickets

Documents

Functional Requirement

Please create data extracts from SAP to send to ROC. They should be in CSV format, and will include the data from listing key combinations Customer / Collection and Sales Org / Collection / Customer Group 9. These extracts will be added to the current nightly batch job which sends SAP data to ROC.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]
Developed an Extract Program "ZISD_CUSTOMER_LISTING_EXTRACT" which generates two CSV files and places the files in Application Server.
1) Customer Collection details files
2)Sales Organization Collection and Customer Group9 details file

Test Plan

[List test scenarios/cases to be executed here]

	Test Scenario	Expected Results
1
2

Solution Details

[Provide complete technical details for configuration or programming here]

Develop an extract Programs which generates two CSV files.

1)Customer Collection File

File Layout:

Name	Table	Field
Customer No	KOTG915	KUNNR
Collection	KOTG915	ZZCOLLECTION
Validity end date of the condition record	KOTG915	DATBI
Validity end date of the condition record	KOTG915	DATAB

Requirements

1) Data is fetched based from Customer/Collection table (KOTG915) based on
Application ( KOTG915-KAPPL = 'V' ) and Material Listing/Exclusion Type (KOTG915-KSCHL = 'Z001") .

2) Sales Org./Collection/Cust.Grp.9 File